package com.kecheng.xinmei.dao;

import com.kecheng.xinmei.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
/**
 * @author gaokecheng
 * @version 1.0
 * @date 2020/11/20 4:21 下午
 */
@Mapper
public interface IndexDao {
    @Select("select * from doctor limit 1")
    Doctor getDoctor();
    @Select("select * from lunbo")
    List<Lunbo> getLunbo();
    @Select("select * from news")
    List<News> getNewsList();
    @Select("select * from topic")
    Topic getTopic();
    @Select("select * from person where ptype = #{type}")
    List<Person> getTeacherList(@Param("type") Integer type);
    @Select("select * from life")
    Life getLife();
    @Select("select * from introduction")
    Introduction getIntroduction();

    @Select("select * from result")
    List<Result> getResultList();
}
